package consts

//sql模板
const(
	SQL_WHERE_1 string = "1=?"
	SQL_WHERE_EQ string = "%s=?"
	SQL_WHERE_NOT_EQ string = "%s <> ?"
	SQL_WHERE_LIKE string = "%s LIKE ?"
	SQL_WHERE_IN string = "%s IN ?"
	SQL_WHERE_NOT_IN string = "%s NOT IN ?"

	SQL_WHERE_EQ1 string = "%s=?"
	SQL_WHERE_EQ2 string = "%s=? AND %s=?"
	SQL_WHERE_EQ3 string = "%s=? AND %s=? AND %s=?"
	SQL_WHERE_EQ4 string = "%s=? AND %s=? AND %s=? AND %s=?"
	SQL_WHERE_EQ5 string = "%s=? AND %s=? AND %s=? AND %s=? AND %s=?"
	SQL_WHERE_EQ6 string = "%s=? AND %s=? AND %s=? AND %s=? AND %s=? AND %s=?"

	SQL_WHERE_AND string = " AND "
	SQL_WHERE_OR string = " OR "

	SQL_ORDER_COMMA string = ","
	SQL_ORDER_ASC1 string = "%s ASC"
	SQL_ORDER_ASC2 string = "%s ASC, %s ASC"
	SQL_ORDER_ASC3 string = "%s ASC, %s ASC, %s ASC"
	SQL_ORDER_DESC1 string = "%s DESC"
	SQL_ORDER_DESC2 string = "%s DESC, %s DESC"
	SQL_ORDER_DESC3 string = "%s DESC, %s DESC, %s DESC"
)